CopyFormat

Applies format into a cell (or range) from another cell. Can apply from any ...

ApplyValidation_DropDown

Adds Validation drop-down to a cell (Data --> Validation --> List), or to a ...

SheetDelete_ANmar

Deletes a sheet from a workbook, checks it is already there first

WorkbookClose_ANmar

Closes a workbook, checks if it is already open first, works for workbooks ...

CreateThumb_IrfanView

Creates a thumb of an image using IrfanView Thumbnail filename will have _th ...

Resources.zip

CreateZipFiles_7Zip

Create zip from list of files listed in List_of_Files separated by comma. The ...

Resources.zip

FindFile

Finds if a workbook is open or not in same Excel session

FixENTERS_File

Removes [Enter]s from imported csv file into Excel worksheet. Smart enough to ...

Import_CSV

Import the CSV file, DOES NOT OPEN, Open does not fix encoding issue, import ...

SortArea1

Sorts a range or area by 1 column given its cell address, with options to ...

SettingRead_JR

Reads setting saved in columns J:R Just like SettingRead, but when we have ...

CellRead (SimpleLookup)

Simply reading a value from a specific cell from a sheet from a workbook ...